import java.sql.*;

public class Testconn {
  public static void main(String[] args) throws Exception {
    Class.forName("org.sqlite.JDBC");
    Connection conn =
      DriverManager.getConnection("jdbc:sqlite:/Users/hbargi/MySQLiteDB");
    Statement stat = conn.createStatement();
  

    ResultSet rs = stat.executeQuery("select * from users;");
    while (rs.next()) {
      System.out.println("name = " + rs.getString("username"));
      System.out.println("pass = " + rs.getString("password"));
    }
    rs.close();
    conn.close();
  }
}